Purchasing Requisition History (POP30200)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchasing Requisition History (POP30200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/POP30200

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Requisition History
Physical Name: POP30200
Technical Name: popRequisitionHist

Group Display Name: Purchasing Requisition History
Group Technical Name: Purchasing Requisition History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	POPRequisitionNumber	POP Requisition Number	String	STR17_POP_Number	17
2	Requisition_Note_Index	Requisition Note Index	Currency	DLR14	14
3	RequisitionDescription	Requisition Description	String	STR60	60
4	RequisitionStatus	Requisition Status	Integer	DDL_Requisition_Status	0
5	COMMNTID	Comment ID	String	STR15_Comment_ID	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['Purchasing Requisition History'].COMMNTID AS 'Purchasing Requisition History-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM POP30200 AS ['Purchasing Requisition History'] INNER JOIN SY04200 AS ['Comment Master'] ON ['Purchasing Requisition History'].COMMNTID = ['Comment Master'].COMMNTID
6	Comment_Note_Index	Comment Note Index	Currency	DLR14	14
7	DOCDATE	Document Date	Date	DT	8
8	REQDATE	Required Date	Date	DATE_L	0
9	REQSTDBY	Requested By	String	STR20_LB	20
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Purchasing Requisition History'].REQSTDBY AS 'Purchasing Requisition History-Requested By' ,['Users Master'].USERID AS 'Users Master-User ID' FROM POP30200 AS ['Purchasing Requisition History'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Purchasing Requisition History'].REQSTDBY = ['Users Master'].USERID
10	PRSTADCD	Primary Shipto Address Code	String	STR15_LBAU	15
11	CMPNYNAM	Company Name	String	STR64_Company_Name	64
12	CONTACT	Contact	String	STR60	60
13	ADDRESS1	Address 1	String	STR60	60
14	ADDRESS2	Address 2	String	STR60	60
15	ADDRESS3	Address 3	String	STR60	60
16	CITY	City	String	STR35	35
17	STATE	State	String	STR30_State	29
18	ZIPCODE	Zip Code	String	STR10	10
19	CCode	Country Code	String	STR6_VAT	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['Purchasing Requisition History'].CCode AS 'Purchasing Requisition History-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM POP30200 AS ['Purchasing Requisition History'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['Purchasing Requisition History'].CCode = ['VAT Country Code MSTR'].CCode
20	COUNTRY	Country	String	STR60	60
21	PHONE1	Phone 1	String	Phone_Number	14
22	PHONE2	Phone 2	String	Phone_Number	14
23	PHONE3	Phone 3	String	Phone_Number3	14
24	FAX	Fax	String	STR14_FAX	14
25	DOCAMNT	Document Amount	Currency	DLR19_RBSO_UTR$	19
26	CREATDDT	Created Date	Date	DT	8
27	MODIFDT	Modified Date	Date	DT	8
28	USER2ENT	User To Enter	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Purchasing Requisition History'].USER2ENT AS 'Purchasing Requisition History-User To Enter' ,['Users Master'].USERID AS 'Users Master-User ID' FROM POP30200 AS ['Purchasing Requisition History'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Purchasing Requisition History'].USER2ENT = ['Users Master'].USERID
29	Flags	Flags	Integer	INT1	1
30	VOIDED	Voided	Boolean	CB	0
31	Workflow_Status	Workflow Status	Integer	Workflow Status	0
32	DomainUserName	Domain User Name	String	STR255	255
33	USERDEF1	User Defined 1	String	STR20	20
34	USERDEF2	User Defined 2	String	STR20	20

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchasing Requisition History (POP30200)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply